package com.erlinyou.im.dao.repository.notice;

import java.util.List;

import org.springframework.data.jpa.repository.Query;

import com.erlinyou.base.dao.BaseRepository;
import com.erlinyou.im.model.notified.ChatNotified;

public interface ChatNotifiedRepository extends BaseRepository<ChatNotified, String>{

	@Query(value="SELECT * from tchat_notified where userid = ?1 ORDER BY create_time DESC",nativeQuery=true)
	List<ChatNotified> findByUserid(Long userid);

	ChatNotified findByUseridAndMsgId(Long userid, String msgId);

}
